home *** CD-ROM | disk | FTP | other *** search
/ SGI Freeware 2002 November / SGI Freeware 2002 November - Disc 3.iso / dist / fw_mysql.idb / usr / freeware / share / mysql-test / t / kill.test.z / kill.test
Text File  |  2002-10-07  |  505b  |  27 lines
  1. connect (con1, localhost, root,,);
  2. connect (con2, localhost, root,,);
  3.  
  4. #remember id of con1
  5. connection con1;
  6. drop table if exists t1;
  7. create table t1 (kill_id int);
  8. insert into t1 values(connection_id());
  9.  
  10. #kill con1
  11. connection con2;
  12. select ((@id := kill_id) - kill_id) from t1; 
  13. kill @id;
  14.  
  15. # Wait for thread to do.
  16. --sleep 5
  17. # verify that con1 is doning a reconnect
  18. connection con1;
  19. ping
  20. ping
  21. select @id != connection_id();
  22.  
  23. #make sure the server is still alive
  24. connection con2;
  25. select 4;
  26. drop table t1;
  27.